Field relationship between tables - Short tip

How often, at the end of data conversion, last time adjustments and last files imported, have you notice that some fields related with tables are not consistent with table information??


To check that, I suggest you to run the Test function at Database > Information for all tables.


How?
For performance reasons, you should first run it with the first 3 options, and then only with the last option activated.


The result can be put into a text file, to screen or into event log.


Nice conversions!!

Non MenuSuite Reports

Did you know that there are a few printable reports that are not related to any Form neither available at MenuSuite?

It's true! 

Hereby three examples and a short explanation of each one.

1. Rep1407 - Bank Account Statement - Cartera
• Purpose: print all the bank account statements (entries included) relative to some Bank Account;
• Filters Available: "Bank Account No." and "Statement No."
• Data Available:

2. Rep5063 - Segment Contacts - CRM
• Purpose: list all the contacts assigned to a segment and detailed information about each contact;
• Filters Available: filters on Segment fields and Contact fields;
• Data Available:

1. Rep5757 - Check on Negative Inventory - Inventory
• Purpose: check inventory consistent issues by location, for instance negative inventory;
• Filters Available: "Location Code"
• Data Available:

NAV Setup Checklist

Hi,


how many of you have already got problems configuring NAV because you missed some table that you think it was other consultant/area responsibility? Probably, it occurs because consultants lack of communication.


Now I found the answer for your problem, or else, Microsoft found it, and I'm gone show you ;)


It calls Setup Checklist and it lives inside NAV. You can find it at Administration > Application Setup > General.

This functionality allows you to manage almost all configurations, across all areas. Beyond direct access to the tables, you can assign a responsible to each table, a date for when it should start and ends, insert comments and define a status of that specific item. It could be: Planning; Started; Completed and Not Used.


Now, regard the scenario that you have two consultants for one implementation:
(A) for SCM area;
(B) to Finance.


The A consultant needs the Posting Groups to configure the items/customers and vendors but consultant B is the responsible of the accounts on each Posting Group Configuration...
The opposite can occurs also.


If both of then were using Setup Checklist, they could start configuring some of the Posting Groups tables and messaging the other, trough comments, to finish that... Isn't it cool??


Now suppose you need to inform your customer of the configurations that it is responsible for. You can assign him to the tables and then print a report with all the stuff it should do, and until when... You can also instill him the job of updating it himself... It saves you some work, don't it?? Isn't it cool? :)


Regards,

Introducing - Simplifying NAV

Hi,

how are you?

Nowadays, more than ever, time is money, and free time is what we never have.

Meetings, discussions, conferences, data sharing between colleagues only happens when with availability and normally for short periods but, in my opinion, it is something with extremely importance for the company's and it resource's “health” and growing. It's all about Internal Knowledge... But Customers always come first, right?

"Simplifying NAV", is a blog about Microsoft Dynamics NAV where we should share and discuss some ideas and give other points of view about NAV implementations, functionalities and how to simplify it. Practical situations with customers, workarounds, corrections, etc... that can be useful at your own customers.

It will be like the meetings and co-sharing we never have time to do.

Regards